MySQL substring between two strings

Just use substring_index() twice:

SELECT substring_index(substring_index(licence_key, 'contract=", -1),
                       "issued=', 1)
FROM table;