Try this : in your query add "WITH (ROWLOCK)"

For example : UPDATE mytable WITH (ROWLOCK) SET myfield = 'whatever'

Hope this will help