While allocating a vm from a pool, whole vms of the
related pool were locked. This was causing unnecessary
lock and increasing the run time of the query. So, locking
the selected row instead to allow concurrent requests to
continue with the next unlocked tuple.