UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X5GL4d/9Ly5MrQ6XdW8nz3XIJr6oj6ACeQPa9xCjRgg='
WHERE
key_id = '5a835bc0382aa256c9ad4eb0f3595a215a5dcc06923e7defcfe761675ac9b100'
AND (
token = 'X5GL4d/9Ly5MrQ6XdW8nz3XIJr6oj6ACeQPa9xCjRgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)