What is the difference between the locking strategies SELECT ... FOR UPDATE and SELECT ... FOR SHARE? Describe a practical case for each.