$sth = $dbh->prepare(q(update foo set bar = ? where quux = ?));
$sth->execute('one', 'two');
$sth->execute('three', 'four');
...