Tell me about optimistic locking: in what cases is it used, what problems can arise, and why not pessimistic?