UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8raoJVmaoLqbTIDqJXjYqoLbqUDXkV4XlIwgLcxgyPM='
WHERE
key_id = '5a2feae6e76720338e8d703e80f7dfbd94cc447abb7cfd862aefb8ac40d032c6'
AND (
token = '8raoJVmaoLqbTIDqJXjYqoLbqUDXkV4XlIwgLcxgyPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)