UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u/jQxXiqYSGoxZ9jCbXw6AjhPCv5+Ksn8H9B7ArglHA='
WHERE
key_id = '31aa0e8f09cea4ee87305c9d1591e158763de763e8fb95e9e146e962c4dad1ac'
AND (
token = 'u/jQxXiqYSGoxZ9jCbXw6AjhPCv5+Ksn8H9B7ArglHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)