I would be interested to know a little more about your SessionLockID column. I would guess that you are using this column to tell a client application weather a record should be temporarily read-only or not.
Tell me more about it and maybe we could look at some alternatives if you would like.
Thanks.
Robert
SQL guy and Houston Magician