Update a valid column when another column has changed
UPDATE text2bid_users
SET valid_phone = CASE WHEN phone != '0000' THEN 0 else valid_phone END,
phone = '0000'
WHERE user_id = 1;


http://sqlfiddle.com/#!9/24784/1