implementing pessimistic and optimistic locks

This and this seem to imply that one would approach pessimistic and optimistic locks by managing the existence of a lock by merely having some extra columns on a database table to denote if a lock exists, the moment a record was last locked, and the id of the party locking it. Transaction locking in something else altogether.