What is Locking in MySQL and when would you use it?

What is Locking in MySQL (or any RDBMS) and when would you use it? A Layman explanation with a Example would be great!