UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qnNUILdEupbh5Dps5PNH5QllCazX3C9t6YFsAZVViSA='
WHERE
key_id = 'ed8034e6194f1979e82ae16e05a0549fa15b285c665f0424645dcb47f8eaa838'
AND (
token = 'qnNUILdEupbh5Dps5PNH5QllCazX3C9t6YFsAZVViSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)