$dbh->do('UPDATE mytable SET myfield = LAST_INSERT_ID(myfield + 1)');
($myfield) = $dbh->selectrow_array('SELECT LAST_INSERT_ID()');