SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '524f910f0ea0cfa1f80fd1a9e4e3e7515c8aea8b9882ae4d45e308ee98337e05' 
  AND token = 'faw+v3Z0oDFEtWW+V6yBpCdkAcnFO6sSgA/CUaJyzec=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00041

JSON explain

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