UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5qI6UupkHmRomcl57u0QfjBiOi7LyGUDRD6hBX2kZlM='
WHERE
key_id = 'c6a0f4c1da2bf2191b048f35cf764bf3139368ee633613b92756677c1d7b4e13'
AND (
token = '5qI6UupkHmRomcl57u0QfjBiOi7LyGUDRD6hBX2kZlM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)