UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9QjOLWlrp9YIXETW5C8cW6G4mPEFyd+QYYRbWm3jTg='
WHERE
key_id = '143f9a9c4fba91be7a44bc2e54f5a2b69024bf708cf6432779bf43d340ec6141'
AND (
token = 'r9QjOLWlrp9YIXETW5C8cW6G4mPEFyd+QYYRbWm3jTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)