UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vgvTPjC2x/3a7qImAhAauign7BPi57an36vKH/Kfhp0='
WHERE
key_id = '51d2ceea3e9324e6ce2e4f6c64c48b1a06a6f17031e936f8db2b279c2a713953'
AND (
token = 'vgvTPjC2x/3a7qImAhAauign7BPi57an36vKH/Kfhp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)