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