UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZYScRWb2GXw1WrsVk1fpIPr4LqtNRPTeesBQHbrY+kE='
WHERE
key_id = 'a9aca5d45b19357089a5b46d1cd0b35bb737c247c29600415e07709c6beddf16'
AND (
token = 'ZYScRWb2GXw1WrsVk1fpIPr4LqtNRPTeesBQHbrY+kE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)