UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yho0tcL128Lh5mYIhq9Rx8TCCj3C+cn2wXC+D6RLZs4='
WHERE
key_id = '7b07adcb52e5dc3bc843b8c31b573a88ce7d7423b24482701011b1be992a7720'
AND (
token = 'yho0tcL128Lh5mYIhq9Rx8TCCj3C+cn2wXC+D6RLZs4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)