SELECT 
  1 
FROM 
  tmall_lock_keys 
WHERE 
  key_id = '43a6b2c2f7c20a1e3b147bec4ca23efdcc136ea196cff52d8c46e4a4a957fbf5' 
  AND token = 'Vk+8tWNyBokZKBfLHzxlGUiPSCSVlL4I5UVd1QXb7iM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00817

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}