Bulk update user's expiration dates via SQL - Paid Memberships Pro

bulk-update-users-expiration-date-pmpro.sql

/**
 * Bulk update all users to have an expiration date that belong to a specific membership level.
 * This code should be run directly inside your WordPress database.
 * Please update the wp_ prefix to match that of your database as well as the membership_id and enddate value (YYYY-MM-DD).
 *
 * IMPORTANT: Have a backup of your site before running this code.
 */

UPDATE wp_pmpro_memberships_users SET enddate = '2020-12-31 00:00:00' WHERE status = 'active' AND membership_id = 1;