my $iface_result = $dbh->prepare("UPDATE device_iface_cache SET interface_status='$stat', lastcheck='$date', hostname='$host' WHERE hostname='$host' AND interface_name='$int_table{$key}';");
$iface_result->execute();

##</code><code>##

my $iface_result = $dbh->prepare("UPDATE device_iface_cache SET interface_status=?, lastcheck=? WHERE hostname=? AND interface_name=?");
$iface_result->execute($stat, $date, $host, $int_table{$key});

##</code><code>##

$db->update('device_iface_cache',
    { interface_status => $stat, lastcheck => $date },
    { hostname => $host, interface_name => $int_table{$key} }
);