Local Reaction

Here is my situation, I need to have mysql do a COUNT(*) in \"column C\" to see how many times lets say the number 5 appears in that column, and if that number 5 appears MORE THAN lets say 10 times, I need for that number 5 to correspond to \"row 5\" and change another column, \"column B\" in \"row 5\" to lets say the number 50. Got it? Anyone know how to do this? Ive been trying to figure it out in my head for a week but I just dont know how to do it. I have done extensive google searches but have come up empty handed. Can anyone tell me if this is even possible to do? I deeply thank in advance anyone who can help me out.