UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xRKrp+5m4XAbQIzUu69w+9jU9DGumDL731ZSmLMOf3g='
WHERE
key_id = '7f65067997b2f17518f73b9758b4b50a4a3fd4ab4770e8f3cb4968571a6f47d3'
AND (
token = 'xRKrp+5m4XAbQIzUu69w+9jU9DGumDL731ZSmLMOf3g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)