pessimistic lock the cache table