UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AZtHWcEPZMOluJ4DKpsWWdvNPrnbd1cMvJO9VE3148U='
WHERE
key_id = 'a980a2aa8c0ebb7178cd0609263b1a8e5e4d3374534d70ad40ebb7d5483dce7a'
AND (
token = 'AZtHWcEPZMOluJ4DKpsWWdvNPrnbd1cMvJO9VE3148U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)