I agree, this sounds like quite a strange DB design to me, why are all the rows the same?
Question: how do you know which row to update, assuming there is a specific row you are interested in?
If you want to update only one row, but ANY row, then try using TOP 1 in your statement. My SQL is a...