UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IbfTHN8zRdJY1Tq+wTMZS8pwKo8KfAaItsPTjn7so2k='
WHERE
key_id = '0bc4f1caf1c9cb8889af7dae80f269b9d6fa8222478686461f46a0def0c61314'
AND (
token = 'IbfTHN8zRdJY1Tq+wTMZS8pwKo8KfAaItsPTjn7so2k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)