UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZPlnGKNcsXNLI9pukf6Uy1qZgIxpRIoIgz9j04PDCok='
WHERE
key_id = '9ff2e1c872c9e828a929ecab5173f716d3905b5ee8f76dff04281f3484e7ceb6'
AND (
token = 'ZPlnGKNcsXNLI9pukf6Uy1qZgIxpRIoIgz9j04PDCok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)