UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HTZ8HnK4/P1R5W/1tZU18+3nUgCiizeLLz9XG2eni+I='
WHERE
key_id = 'aa0ba5e8716eb9af7b820016cbecb204e78e3e8bbe2afea95df5bc807fda3410'
AND (
token = 'HTZ8HnK4/P1R5W/1tZU18+3nUgCiizeLLz9XG2eni+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)