Looking for meta data which matches certain criteria and was created after a certain date
Suggest staring with this:

AND `meta_id` IN 
        (SELECT SUBSTRING_INDEX(`meta_value`, '!', 1) 
         FROM `wp_postmeta` 
         WHERE `meta_key` 
         LIKE 'wpcf-post-like-date-link' 
         ORDER BY `meta_id` 
         DESC)


LIKE text searching, sorting with the ORDER, additional subquery on the same wp_postmeta table are sources of the lengthy query execution. Rewriting subqueries as joins