Make custom field Expiry = EOT Date

Have imported some 17000 records and placed the members expiry date from that system into a custom field called Expiry. I need to make the EOT date in s2member = Expiry (custom field).

Found the following on the forum, which I think is a step in the right direction to find the existing EOT:

“global $wpdb;
$query = “SELECT user_id, meta_value FROM wp_usermeta WHERE meta_key = ‘wp_s2member_auto_eot_time’ AND meta_value != ””;
foreach($wpdb->get_results($query) as $result)
if (wp_s2member_auto_eot_time >= “31 July 2014” {
[do this action]
}
”