UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QFWRp2IryL/UZCKCZqfQiy1ImU85UwcZ/RGxS7r/wX8='
WHERE
key_id = 'a50d6830df29055502165f28ec4117180d47cf31a0c047fa52425129ff104606'
AND (
token = 'QFWRp2IryL/UZCKCZqfQiy1ImU85UwcZ/RGxS7r/wX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)