MYSQL Transaction Lock 1 row for update

SET AUTOCOMMIT=0
START TRANSACTION;
SELECT * FROM personnes FOR UPDATE LIMIT 1;
UPDATE personnes SET NAME='Alex' WHERE ID=5;
COMMIT;

Source : http://dev.mysql.com/doc/refman/5.0/fr/commit.html