$dbh->do("LOCK TABLES tbl WRITE");
$dbh->do("$various_sql_stuff_without_getting_tangled");
$dbh->do("UNLOCK TABLES");