UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qGYpY84aGH7NSF1B46JMQI7Q4wZwtZLL1tZ4f5jUGAc='
WHERE
key_id = '95192c78d0a90e1e24dced4d3973bc7efcddd328eadd25caabfc362637841d9f'
AND (
token = 'qGYpY84aGH7NSF1B46JMQI7Q4wZwtZLL1tZ4f5jUGAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)