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