UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9t1XuJNA0A6iY0/b2czGHnolmRQR1dDMjCCZ4mzx3Sk='
WHERE
key_id = '01aa69c7f823ca5197778a49ef12d41faf997bb82e18950b74ea4aca8649b49f'
AND (
token = '9t1XuJNA0A6iY0/b2czGHnolmRQR1dDMjCCZ4mzx3Sk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)