You need to close the REPLACE function properly and add a closing parenthesis for the UPDATE statement.
this will work fine now
global $wpdb; $wpdb->query("UPDATE wp_mailpoet_subscribers SET status = REPLACE(status, 'unconfirmed', 'subscribed')");