Added note about pessimistic locking

@GrahamCampbell Is this the best way to highlight the note?