UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5kuIUdeACEXWvPaHrgGzIRFY+CfxG5MeTisbvnj14u4='
WHERE
key_id = 'e941205c21e6ae56b7678fa87b4ef21929df4f4276e13941263db1f72de7e197'
AND (
token = '5kuIUdeACEXWvPaHrgGzIRFY+CfxG5MeTisbvnj14u4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)