The psychologically charged paintings of 16th-century artist Lorenzo Lotto explore hermeticism and the ‘pure profane’