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