yes you are correct...we need to lock the record for updation.
Various factors have been identified for the high CPU utilization and this query is one of the factors.