$dbh = DBI->connect($dsn, $user, $passwd,{ RaiseError => 1, AutoCommit => 1 });

$sth = $dbh->prepare( "UPDATE $table SET value = ? WHERE key = ?" );
$sth->execute( $value, 3 );