Either we can use lock hint based on sensitive of data or Non Clustered Index which will create addition maintenance work. My choice is Non Clustered index.