SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '6db7e5b1f751613fdedc2e2552cb2cd97e4d7ff8e5041cc51a584771030451d7' 
  AND token = 'o8Uitqj9j0ToMzyJN7evljxYt1Gq7wmujK3aX3Mzatw=' 
  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"
    }
  }
}