After some more read maybe this would lock a record (and only one record) until all work is done,

BEGIN TRAN

SELECT * FROM tblName WITH (HOLDLOCK, ROWLOCK)

WHERE ID = someID

/* While the record is locked do work*/

COMMIT TRAN