Remove expensive RDBMS queries in lock acquisition logic

There are queries like
"update NEXT_LOCK_ID set nl_next = 163084841;" which can be entirely skipped
the ACID impl doesn't require globally unique lock ids
because locks are marked as txn.id
In a particular instance we observed this logic taking multiple seconds in mysql