I would like to set the values of all items in master category 1 for metatags_model_status to all = 0

I have some other values I want changed as well. But this information should get me started.

I tried some variations of the below syntax without success
SELECT * FROM `znc_products` WHERE `master_categories_id` = 1
SET metatags_model_status = replace(metatags_model_status,'1','0');

Further to this, I would like to update all the meta keywords and such for all items in master category 1

Yes, I have backed up my DB