UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '804m/T32YJqoJ0kdP8QkFXIC7N+jmUB56czI56kgfxE='
WHERE
key_id = 'b657151f9142cc8ec99a2327a44731ff596d9559df7e0b8c2dabc38a71a5e5eb'
AND (
token = '804m/T32YJqoJ0kdP8QkFXIC7N+jmUB56czI56kgfxE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)