UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PXYleEGAXvIp+7zhnKqfwdfwqoSi/s5TAGmnI2lA3Bs='
WHERE
key_id = '00a01b91198c2b1fc9c12c18092e8806ce2b3c4fbb4d73cad5eb4bd3facbf413'
AND (
token = 'PXYleEGAXvIp+7zhnKqfwdfwqoSi/s5TAGmnI2lA3Bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)