UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x9ROkpwU8jSHM3EoVlZK0Ph7wQsfkLO4EUcd+W+tL7A='
WHERE
key_id = '7455b98988fee1b37a898d08a184d08bf54b602d29f2e6df3f742be35b93cb53'
AND (
token = 'x9ROkpwU8jSHM3EoVlZK0Ph7wQsfkLO4EUcd+W+tL7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)