Mysql Search and Replace query

I'm trying to search a column for a specific result. If found change the value of another column in the same table with a specific number.

Example Using table product while searching column manufacturer_id for number 5. If found change the value of status to 0 on the same row.

I have been able to modify examples on the net but I have only been successful in changing all rows to 0 or just locating the "5" in manufacturer_id and errors on the update side. I have tried to do it with if then statements with no luck. Any suggestions would be greatly appreciated.