UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oSgG0eyFcnzHvZx4eF85dS6eBciDOd+IcNw/2vUaO6g='
WHERE
key_id = '79d2173fe9132f7d18189878be542be273f9b8441f8355431ed2a49ec4680dec'
AND (
token = 'oSgG0eyFcnzHvZx4eF85dS6eBciDOd+IcNw/2vUaO6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)