UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UAFsXW7LrgnSghVbGs3vw6s3FAliqSIrIk5qF5UAZGs='
WHERE
key_id = '2b2c98ce695b5caefbda0aae536a81880c5bde2582374dfb53df4c7a3ba600ed'
AND (
token = 'UAFsXW7LrgnSghVbGs3vw6s3FAliqSIrIk5qF5UAZGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)