UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gsNZVkg5zboEFc1HyRZvxdqnpxPVy7Q2zWPNIGI3FPM='
WHERE
key_id = '1b651d173cb03321678f56b56f9a26a62e3399c5492c16455cd64903c27a056a'
AND (
token = 'gsNZVkg5zboEFc1HyRZvxdqnpxPVy7Q2zWPNIGI3FPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)