The below is a specific update query for a CB user. Should be able to use as an example to construct whatever update query you need.
Code:
UPDATE `#__comprofiler` SET `cb_myfield` = 1 WHERE `user_id` = '[user_id]'
Note in the above you can use #__ instead of supplying the table prefix as it'll automatically be added.