UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpShHgRi0Kel4DF8/5fEXAUtXACYqMXQw5fWy7b/Iyo='
WHERE
key_id = 'f7057ff69e7e95f845798829cb7d3a04d015356cb0eb04062b81a70d5aef7eb4'
AND (
token = 'zpShHgRi0Kel4DF8/5fEXAUtXACYqMXQw5fWy7b/Iyo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)