UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zjIhbJHZrIgUJC+TYC3OPR2fh7+tM/AnDtNSLxYtUf0='
WHERE
key_id = '497e68df7dfa2df393b673e54d63fbd562dcf1dc7e6eac2148f51ebb400c606a'
AND (
token = 'zjIhbJHZrIgUJC+TYC3OPR2fh7+tM/AnDtNSLxYtUf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)